﻿CREATE TABLE [dbo].[StudentCourse]
(
	[ID] INT NOT NULL PRIMARY KEY IDENTITY, 
    [CourseSemesterId] INT NOT NULL, 
    [StudentId] INT NOT NULL, 
    CONSTRAINT [FK_StudentCourse_ToCourseSemester] FOREIGN KEY ([CourseSemesterId]) REFERENCES [CourseSemester]([Id]), 
    CONSTRAINT [FK_StudentCourse_ToStudent] FOREIGN KEY ([StudentId]) REFERENCES [Student]([ID])
)
